Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	17379
Missing cells	17379
Missing cells (%)	5.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.3 MiB
Average record size in memory	136.0 B

Variable types

NUM	10
CAT	3
BOOL	3
UNSUPPORTED	1

Warnings

`dteday` has a high cardinality: 731 distinct values	High cardinality
`atemp` is highly correlated with `temp`	High correlation
`temp` is highly correlated with `atemp`	High correlation
`cnt` is highly correlated with `registered`	High correlation
`registered` is highly correlated with `cnt`	High correlation
`instant` has 17379 (100.0%) missing values	Missing
`dteday` is uniformly distributed	Uniform
`instant` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`hr` has 726 (4.2%) zeros	Zeros
`weekday` has 2502 (14.4%) zeros	Zeros
`windspeed` has 2180 (12.5%) zeros	Zeros
`casual` has 1581 (9.1%) zeros	Zeros

Reproduction

Analysis started	2020-11-19 18:57:31.040082
Analysis finished	2020-11-19 18:57:44.025302
Duration	12.99 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

instant
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	17379
Missing (%)	100.0%
Memory size	135.9 KiB

dteday
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	731
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	135.8 KiB

2011-12-31	24
2012-07-30	24
2012-03-14	24
2011-08-03	24
2012-02-08	24
Other values (726)	17259

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2011-12-31	24	0.1%
2012-07-30	24	0.1%
2012-03-14	24	0.1%
2011-08-03	24	0.1%
2012-02-08	24	0.1%
2011-04-26	24	0.1%
2011-10-16	24	0.1%
2012-03-27	24	0.1%
2011-10-27	24	0.1%
2011-08-18	24	0.1%
Other values (721)	17139	98.6%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

season
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.8 KiB

3	4496
2	4409
1	4242
4	4232

Frequencies
Length

Value	Count	Frequency (%)
3	4496	25.9%
2	4409	25.4%
1	4242	24.4%
4	4232	24.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

yr
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.8 KiB

1	8734
0	8645

Common Values
Chart

Value	Count	Frequency (%)
1	8734	50.3%
0	8645	49.7%

mnth
Real number (ℝ_≥0)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.537775476
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	135.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.438775714
Coefficient of variation (CV)	0.5259855935
Kurtosis	-1.201878197
Mean	6.537775476
Median Absolute Deviation (MAD)	3
Skewness	-0.009253248383
Sum	113620
Variance	11.82517841
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	1488	8.6%
5	1488	8.6%
12	1483	8.5%
8	1475	8.5%
3	1473	8.5%
10	1451	8.3%
6	1440	8.3%
11	1437	8.3%
9	1437	8.3%
4	1437	8.3%
Other values (2)	2770	15.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1429	8.2%
2	1341	7.7%
3	1473	8.5%
4	1437	8.3%
5	1488	8.6%

Value	Count	Frequency (%)
12	1483	8.5%
11	1437	8.3%
10	1451	8.3%
9	1437	8.3%
8	1475	8.5%

hr
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.54675183
Minimum	0
Maximum	23
Zeros	726
Zeros (%)	4.2%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	6
median	12
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.914405095
Coefficient of variation (CV)	0.5988181957
Kurtosis	-1.198020588
Mean	11.54675183
Median Absolute Deviation (MAD)	6
Skewness	-0.01067990952
Sum	200671
Variance	47.80899782
Monotocity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
16	730	4.2%
17	730	4.2%
15	729	4.2%
13	729	4.2%
14	729	4.2%
22	728	4.2%
18	728	4.2%
19	728	4.2%
20	728	4.2%
21	728	4.2%
Other values (14)	10092	58.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	726	4.2%
1	724	4.2%
2	715	4.1%
3	697	4.0%
4	697	4.0%

Value	Count	Frequency (%)
23	728	4.2%
22	728	4.2%
21	728	4.2%
20	728	4.2%
19	728	4.2%

holiday
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.8 KiB

0	16879
1	500

Common Values
Chart

Value	Count	Frequency (%)
0	16879	97.1%
1	500	2.9%

weekday
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.003682605
Minimum	0
Maximum	6
Zeros	2502
Zeros (%)	14.4%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.005771456
Coefficient of variation (CV)	0.6677707733
Kurtosis	-1.255996891
Mean	3.003682605
Median Absolute Deviation (MAD)	2
Skewness	-0.002998221376
Sum	52201
Variance	4.023119134
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	2512	14.5%
0	2502	14.4%
5	2487	14.3%
1	2479	14.3%
3	2475	14.2%
4	2471	14.2%
2	2453	14.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2502	14.4%
1	2479	14.3%
2	2453	14.1%
3	2475	14.2%
4	2471	14.2%

Value	Count	Frequency (%)
6	2512	14.5%
5	2487	14.3%
4	2471	14.2%
3	2475	14.2%
2	2453	14.1%

workingday
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.8 KiB

1	11865
0	5514

Common Values
Chart

Value	Count	Frequency (%)
1	11865	68.3%
0	5514	31.7%

weathersit
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	135.8 KiB

1	11413
2	4544
3	1419
4	3

Frequencies
Length

Value	Count	Frequency (%)
1	11413	65.7%
2	4544	26.1%
3	1419	8.2%
4	3	< 0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

temp
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	50
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4969871684
Minimum	0.02
Maximum	1
Zeros	0
Zeros (%)	0.0%
Memory size	135.8 KiB

Quantile statistics

Minimum	0.02
5-th percentile	0.2
Q1	0.34
median	0.5
Q3	0.66
95-th percentile	0.8
Maximum	1
Range	0.98
Interquartile range (IQR)	0.32

Descriptive statistics

Standard deviation	0.1925561212
Coefficient of variation (CV)	0.3874468668
Kurtosis	-0.9418442041
Mean	0.4969871684
Median Absolute Deviation (MAD)	0.16
Skewness	-0.006020883348
Sum	8637.14
Variance	0.03707785983
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.62	726	4.2%
0.66	693	4.0%
0.64	692	4.0%
0.7	690	4.0%
0.6	675	3.9%
0.36	671	3.9%
0.34	645	3.7%
0.3	641	3.7%
0.4	614	3.5%
0.32	611	3.5%
Other values (40)	10721	61.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.02	17	0.1%
0.04	16	0.1%
0.06	16	0.1%
0.08	17	0.1%
0.1	51	0.3%

Value	Count	Frequency (%)
1	1	< 0.1%
0.98	1	< 0.1%
0.96	16	0.1%
0.94	17	0.1%
0.92	49	0.3%

atemp
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	65
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4757751021
Minimum	0
Maximum	1
Zeros	2
Zeros (%)	< 0.1%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2121
Q1	0.3333
median	0.4848
Q3	0.6212
95-th percentile	0.7424
Maximum	1
Range	1
Interquartile range (IQR)	0.2879

Descriptive statistics

Standard deviation	0.1718502156
Coefficient of variation (CV)	0.3612005228
Kurtosis	-0.8454118948
Mean	0.4757751021
Median Absolute Deviation (MAD)	0.1364
Skewness	-0.09042885856
Sum	8268.4955
Variance	0.02953249661
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6212	988	5.7%
0.5152	618	3.6%
0.4091	614	3.5%
0.3333	600	3.5%
0.6667	593	3.4%
0.6061	588	3.4%
0.5303	579	3.3%
0.5	575	3.3%
0.4545	559	3.2%
0.303	549	3.2%
Other values (55)	11116	64.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
0.0152	4	< 0.1%
0.0303	8	< 0.1%
0.0455	9	0.1%
0.0606	14	0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.9848	2	< 0.1%
0.9545	1	< 0.1%
0.9242	5	< 0.1%
0.9091	5	< 0.1%

hum
Real number (ℝ_≥0)

Distinct	89
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.6272288394
Minimum	0
Maximum	1
Zeros	22
Zeros (%)	0.1%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0.31
Q1	0.48
median	0.63
Q3	0.78
95-th percentile	0.93
Maximum	1
Range	1
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.1929298341
Coefficient of variation (CV)	0.3075908216
Kurtosis	-0.8261167359
Mean	0.6272288394
Median Absolute Deviation (MAD)	0.15
Skewness	-0.1112871494
Sum	10900.61
Variance	0.03722192087
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.88	657	3.8%
0.83	630	3.6%
0.94	560	3.2%
0.87	488	2.8%
0.7	430	2.5%
0.66	388	2.2%
0.65	387	2.2%
0.69	359	2.1%
0.55	352	2.0%
0.74	341	2.0%
Other values (79)	12787	73.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22	0.1%
0.08	1	< 0.1%
0.1	1	< 0.1%
0.12	1	< 0.1%
0.13	1	< 0.1%

Value	Count	Frequency (%)
1	270	1.6%
0.97	1	< 0.1%
0.96	3	< 0.1%
0.94	560	3.2%
0.93	331	1.9%

windspeed
Real number (ℝ_≥0)

ZEROS

Distinct	30
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1900976063
Minimum	0
Maximum	0.8507
Zeros	2180
Zeros (%)	12.5%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1045
median	0.194
Q3	0.2537
95-th percentile	0.4179
Maximum	0.8507
Range	0.8507
Interquartile range (IQR)	0.1492

Descriptive statistics

Standard deviation	0.1223402286
Coefficient of variation (CV)	0.6435653291
Kurtosis	0.5908204107
Mean	0.1900976063
Median Absolute Deviation (MAD)	0.0895
Skewness	0.5749052035
Sum	3303.7063
Variance	0.01496713153
Monotocity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	2180	12.5%
0.1343	1738	10.0%
0.1642	1695	9.8%
0.194	1657	9.5%
0.1045	1617	9.3%
0.2239	1513	8.7%
0.0896	1425	8.2%
0.2537	1295	7.5%
0.2836	1048	6.0%
0.2985	808	4.6%
Other values (20)	2403	13.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2180	12.5%
0.0896	1425	8.2%
0.1045	1617	9.3%
0.1343	1738	10.0%
0.1642	1695	9.8%

Value	Count	Frequency (%)
0.8507	2	< 0.1%
0.8358	1	< 0.1%
0.806	2	< 0.1%
0.7761	1	< 0.1%
0.7463	2	< 0.1%

casual
Real number (ℝ_≥0)

ZEROS

Distinct	322
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35.67621842
Minimum	0
Maximum	367
Zeros	1581
Zeros (%)	9.1%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	17
Q3	48
95-th percentile	138.1
Maximum	367
Range	367
Interquartile range (IQR)	44

Descriptive statistics

Standard deviation	49.30503039
Coefficient of variation (CV)	1.382013918
Kurtosis	7.571001747
Mean	35.67621842
Median Absolute Deviation (MAD)	16
Skewness	2.499236891
Sum	620017
Variance	2430.986021
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1581	9.1%
1	1082	6.2%
2	798	4.6%
3	697	4.0%
4	561	3.2%
5	509	2.9%
6	448	2.6%
7	405	2.3%
8	377	2.2%
9	348	2.0%
Other values (312)	10573	60.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1581	9.1%
1	1082	6.2%
2	798	4.6%
3	697	4.0%
4	561	3.2%

Value	Count	Frequency (%)
367	1	< 0.1%
362	1	< 0.1%
361	1	< 0.1%
357	1	< 0.1%
356	1	< 0.1%

registered
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	776
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	153.7868692
Minimum	0
Maximum	886
Zeros	24
Zeros (%)	0.1%
Memory size	135.8 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	34
median	115
Q3	220
95-th percentile	465
Maximum	886
Range	886
Interquartile range (IQR)	186

Descriptive statistics

Standard deviation	151.3572859
Coefficient of variation (CV)	0.9842016207
Kurtosis	2.750017757
Mean	153.7868692
Median Absolute Deviation (MAD)	89
Skewness	1.557904226
Sum	2672662
Variance	22909.028
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	307	1.8%
3	294	1.7%
5	287	1.7%
6	266	1.5%
2	245	1.4%
1	201	1.2%
7	200	1.2%
8	190	1.1%
9	178	1.0%
11	140	0.8%
Other values (766)	15071	86.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	24	0.1%
1	201	1.2%
2	245	1.4%
3	294	1.7%
4	307	1.8%

Value	Count	Frequency (%)
886	1	< 0.1%
885	1	< 0.1%
876	2	< 0.1%
871	1	< 0.1%
860	1	< 0.1%

cnt
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	869
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	189.4630876
Minimum	1
Maximum	977
Zeros	0
Zeros (%)	0.0%
Memory size	135.8 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	40
median	142
Q3	281
95-th percentile	563.1
Maximum	977
Range	976
Interquartile range (IQR)	241

Descriptive statistics

Standard deviation	181.3875991
Coefficient of variation (CV)	0.9573769823
Kurtosis	1.417203281
Mean	189.4630876
Median Absolute Deviation (MAD)	112
Skewness	1.277411604
Sum	3292679
Variance	32901.4611
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	260	1.5%
6	236	1.4%
4	231	1.3%
3	224	1.3%
2	208	1.2%
7	198	1.1%
8	182	1.0%
1	158	0.9%
10	155	0.9%
11	147	0.8%
Other values (859)	15380	88.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	158	0.9%
2	208	1.2%
3	224	1.3%
4	231	1.3%
5	260	1.5%

Value	Count	Frequency (%)
977	1	< 0.1%
976	1	< 0.1%
970	1	< 0.1%
968	1	< 0.1%
967	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	instant	dteday	season	mnth	hr	weekday	weathersit	temp	atemp	hum	windspeed	casual	registered	cnt
0	None	2011-01-01	1	1	0	6	1	0.24	0.2879	0.81	0.0000	3	13	16
1	None	2011-01-01	1	1	1	6	1	0.22	0.2727	0.80	0.0000	8	32	40
2	None	2011-01-01	1	1	2	6	1	0.22	0.2727	0.80	0.0000	5	27	32
3	None	2011-01-01	1	1	3	6	1	0.24	0.2879	0.75	0.0000	3	10	13
4	None	2011-01-01	1	1	4	6	1	0.24	0.2879	0.75	0.0000	0	1	1
5	None	2011-01-01	1	1	5	6	2	0.24	0.2576	0.75	0.0896	0	1	1
6	None	2011-01-01	1	1	6	6	1	0.22	0.2727	0.80	0.0000	2	0	2
7	None	2011-01-01	1	1	7	6	1	0.20	0.2576	0.86	0.0000	1	2	3
8	None	2011-01-01	1	1	8	6	1	0.24	0.2879	0.75	0.0000	1	7	8
9	None	2011-01-01	1	1	9	6	1	0.32	0.3485	0.76	0.0000	8	6	14

Last rows

	instant	dteday	season	yr	mnth	hr	weekday	workingday	weathersit	temp	atemp	hum	windspeed	casual	registered	cnt
17369	None	2012-12-31	1	1	12	14	1	1	2	0.28	0.2727	0.45	0.2239	62	185	247
17370	None	2012-12-31	1	1	12	15	1	1	2	0.28	0.2879	0.45	0.1343	69	246	315
17371	None	2012-12-31	1	1	12	16	1	1	2	0.26	0.2576	0.48	0.1940	30	184	214
17372	None	2012-12-31	1	1	12	17	1	1	2	0.26	0.2879	0.48	0.0896	14	150	164
17373	None	2012-12-31	1	1	12	18	1	1	2	0.26	0.2727	0.48	0.1343	10	112	122
17374	None	2012-12-31	1	1	12	19	1	1	2	0.26	0.2576	0.60	0.1642	11	108	119
17375	None	2012-12-31	1	1	12	20	1	1	2	0.26	0.2576	0.60	0.1642	8	81	89
17376	None	2012-12-31	1	1	12	21	1	1	1	0.26	0.2576	0.60	0.1642	7	83	90
17377	None	2012-12-31	1	1	12	22	1	1	1	0.26	0.2727	0.56	0.1343	13	48	61
17378	None	2012-12-31	1	1	12	23	1	1	1	0.26	0.2727	0.65	0.1343	12	37	49

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows